﻿CREATE PROCEDURE [dbo].[Hogar_Rol_ObtenerTodos]   
AS 
BEGIN

/*****************************************************************************************************************************************/
-- Author: Carlos Mendoza
-- Purpose:   obtener todas los roles 
-- Returns:    Rol
/*****************************************************************************************************************************************/ 
	
	SELECT  [RolId],
			[Descripcion]
	FROM	[dbo].[Rol] WITH (NOLOCK)
	ORDER BY [Descripcion]
	
END